Tabela TimeConstraint

Definicja tabeli TimeConstraint

Name

TimeConstraint

Code

TimeConstraint

Comment

Ograniczenia czasowe dla pacjenta na zakres godzin i dzien tygodnia


Lista kolumn tabeli TimeConstraint

Name

Code

TimeConstraintID

TimeConstraintID

PersonID

PersonID

StartDT

StartDT

StopDT

StopDT

WeakDayID

WeakDayID

Comments

Comments

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT


Kolumna TimeConstraintID tabeli TimeConstraint

Definicja kolumny TimeConstraintID tabeli TimeConstraint

Name

TimeConstraintID

Code

TimeConstraintID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli TimeConstraint

Definicja kolumny PersonID tabeli TimeConstraint

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli TimeConstraint

Definicja kolumny StartDT tabeli TimeConstraint

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

Zakres dat objecia opieka przez stacje dializ


Kolumna StopDT tabeli TimeConstraint

Definicja kolumny StopDT tabeli TimeConstraint

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Zakres dat objecia opieka przez stacje dializ


Kolumna WeakDayID tabeli TimeConstraint

Definicja kolumny WeakDayID tabeli TimeConstraint

Name

WeakDayID

Code

WeakDayID

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna Comments tabeli TimeConstraint

Definicja kolumny Comments tabeli TimeConstraint

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli TimeConstraint

Definicja kolumny InsertingPerson tabeli TimeConstraint

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDate tabeli TimeConstraint

Definicja kolumny InsertDate tabeli TimeConstraint

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

Data utworzenia rekordu


Kolumna LastModifiedPerson tabeli TimeConstraint

Definicja kolumny LastModifiedPerson tabeli TimeConstraint

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

Ostatnio modyfikujaca osoba


Kolumna LastModifiedDT tabeli TimeConstraint

Definicja kolumny LastModifiedDT tabeli TimeConstraint

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Lista kluczy tabeli TimeConstraint

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TimeConstraint

Definicja klucza Identifier_1 tabeli TimeConstraint

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment